package com.josn.mapper;

import com.josn.pojo.User;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface UserMapper {

    //按照用户名查找
    @Select("select * from user where username = #{username}")
    User findByUserName(String username);

    //增加
    @Insert("insert into user(username,password,create_time,update_time) values (#{username},#{password},now(),now())")
    void add(String username,String password);

    //更新用户信息
    @Update("update user set nickname=#{nickname},email=#{email},update_time=now() where id=#{id}")
    void update(User user);

    //更新用户头像
    @Update("update user set user_pic=#{avatarurl} where id=#{id}")
    void updateavatar(String avatarurl,Integer id);

    //修改用户密码
    @Update("update user set password=#{new_pwd} where id=#{id}")
    void updatepwd(String new_pwd,Integer id);
}
